package com.hwua.tonyshop.criteria;
	
import com.slkj.autocode.entity.Page;
import com.hwua.tonyshop.entity.pojo.CartInfo;

/**
* 
* @author sunny Yang [杨松彦]
* @QQ 550358261
* @date 2018-04-16
* @discribe
* >、<、>=、<=、=、!=、like、
* is null、is not null、in、not in
*
*/
public class CartInfoCriteria extends CartInfo{
	/**
	* 版本号
	*/
	private static final long serialVersionUID = 1L;
	private String groupBy123;//分组
	private String having123;//分组过滤
	private String orderBy123;//排序
	private Page page123;
	private String condition123="";//纯条件
	private String selectCondition123;//查询条件
	private String sql123;
	private CartInfo cartInfo;
	private String feid123;//字段用于统计查询时设置

	public CartInfoCriteria() {

	}
	public String getFeid123() {
		return feid123;
	}
	public void setFeid123(String feid) {
		this.feid123 = feid;
	}
	public CartInfo getCartInfo() {
		return cartInfo;
	}
	public void setCartInfo(CartInfo cartInfo) {
		this.cartInfo = cartInfo;
		initCartInfo(cartInfo);
	}

	public String getSql123() {
		return sql123;
	}

	public void setSql123(String sql123) {
		this.sql123 = sql123;
	}

	public String getSelectCondition123() {
		if(selectCondition123==null){
			if(condition123.trim().length()>0){
				condition123 = "where "+condition123;
			}
			selectCondition123 = condition123;
			if(groupBy123!=null){
				selectCondition123 += " group by "+groupBy123+" ";
			}
			if(having123!=null){
				selectCondition123 += "having "+having123+" ";
			}
			if(orderBy123!=null){
				selectCondition123 += "order by "+orderBy123+" ";
			}
			if(page123!=null){
				selectCondition123 += "limit "+((page123.getPageNumber()-1)*page123.getPageSize())+","+page123.getPageSize();
			}
			selectCondition123 = selectCondition123.trim();
		}
		System.out.println("查询条件："+selectCondition123);
		return selectCondition123;
	}
	public void setSelectCondition123(String selectCondition) {
		this.selectCondition123 = selectCondition;
	}
	public String getCondition123() {
		System.out.println("纯条件："+condition123);
		return condition123;
	}
	public void setCondition123(String condition) {
		this.condition123 = condition;
	}
	public CartInfoCriteria page(Page value){
		page123 = value;
		return this;
	}
	public CartInfoCriteria groupBy(String value){
		groupBy123 = value;
		return this;
	}
	public CartInfoCriteria having(String value){
		having123 = value;
		return this;
	}
	public CartInfoCriteria orderBy(String value){
		orderBy123 = value;
		return this;
	}

	/*public String getSqlAll(String tableName){
		String sql = "";
		if("where ".equals(condition123)){
			sql = "select * from `"+tableName+"` ";
		}else{
			sql = "select * from `"+tableName+"` "+condition123+" ";
		}
		if(groupBy123!=null){
			sql += sql+" group by "+groupBy123+" ";
		}
		if(having123!=null){
			sql += "having "+having123+" ";
		}
		if(orderBy123!=null){
			sql += "order by "+orderBy123+" ";
		}
		if(page123!=null){
			sql += "limit "+((page123.getPageNumber()-1)*page123.getPageSize())+","+page123.getPageSize();
		}
		sql = sql.trim();
		return sql; 
	}*/

/************以下为纯条件的拼接*******************/

	public CartInfoCriteria andIdEquals(Integer id){
		if(id!=null){
			if(condition123.length()>0){
				condition123 += "and `id`="+id+" ";
			}else{
				condition123 += "`id`="+id+" ";
			}
		}
		return this;
	}
	
	public CartInfoCriteria orIdEquals(Integer id){
		if(id!=null){
			if(condition123.length()>0){
				condition123 += "or `id`="+id+" ";
			}else{
				condition123 += "`id`="+id+" ";
			}
		}
		return this;
	}
	
	public CartInfoCriteria andIdNotEquals(Integer id){
		if(id!=null){
			if(condition123.length()>0){
				condition123 += "and `id`!="+id+" ";
			}else{
				condition123 += "`id`!="+id+" ";
			}
		}
		return this;
	}
	public CartInfoCriteria orIdNotEquals(Integer id){
		if(id!=null){
			if(condition123.length()>0){
				condition123 += "or `id`!="+id+" ";
			}else{
				condition123 += "`id`!="+id+" ";
			}
		}
		return this;
	}
	/**
	 * 大于
	 * @param 
	 * @return
	 */
	public CartInfoCriteria andIdGreaterThan(Integer id){
		if(id!=null){
			if(condition123.length()>0){
				condition123 += "and `id`>"+id+" ";
			}else{
				condition123 += "`id`>"+id+" ";
			}
		}
		return this;
	}
	public CartInfoCriteria orIdGreaterThan(Integer id){
		if(id!=null){
			if(condition123.length()>0){
				condition123 += "or `id`>"+id+" ";
			}else{
				condition123 += "`id`>"+id+" ";
			}
		}
		return this;
	}
	
	
	public CartInfoCriteria andIdLessThan(Integer id){
		if(id!=null){
			if(condition123.length()>0){
				condition123 += "and `id`<"+id+" ";
			}else{
				condition123 += "`id`<"+id+" ";
			}
		}
		return this;
	}
	public CartInfoCriteria orIdLessThan(Integer id){
		if(id!=null){
			if(condition123.length()>0){
				condition123 += "or `id`<"+id+" ";
			}else{
				condition123 += "`id`<"+id+" ";
			}
		}
		return this;
	}
	
	public CartInfoCriteria andIdGreadterThanAndEquals(Integer id){
		if(id!=null){
			if(condition123.length()>0){
				condition123 += "and `id`>="+id+" ";
			}else{
				condition123 += "`id`>="+id+" ";
			}
		}
		return this;
	}
	public CartInfoCriteria orIdGreadterThanAndEquals(Integer id){
		if(id!=null){
			if(condition123.length()>0){
				condition123 += "or `id`>="+id+" ";
			}else{
				condition123 += "`id`>="+id+" ";
			}
		}
		return this;
	}
	
	public CartInfoCriteria andIdLessThanAndEquals(Integer id){
		if(id!=null){
			if(condition123.length()>0){
				condition123 += "and `id`<="+id+" ";
			}else{
				condition123 += "`id`<="+id+" ";
			}
		}
		return this;
	}
	public CartInfoCriteria orIdLessThanAndEquals(Integer id){
		if(id!=null){
			if(condition123.length()>0){
				condition123 += "or `id`<="+id+" ";
			}else{
				condition123 += "`id`<="+id+" ";
			}
		}
		return this;
	}
	
	public CartInfoCriteria andIdLike(Integer id){
		if(id!=null){
			if(condition123.length()>0){
				condition123 += "and `id` like "+id+" ";
			}else{
				condition123 += "`id` like "+id+" ";
			}
		}
		return this;
	}
	public CartInfoCriteria orIdLike(Integer id){
		if(id!=null){
			if(condition123.length()>0){
				condition123 += "or `id` like "+id+" ";
			}else{
				condition123 += "`id` like "+id+" ";
			}
		}
		return this;
	}
	
	public CartInfoCriteria andIdIsNull(){
			if(condition123.length()>0){
				condition123 += "and `id` is null";
			}else{
				condition123 += "`id` is null";
			}
		return this;
	}
	public CartInfoCriteria orIdIsNull(){
		if(condition123.length()>0){
			condition123 += "or `id` is null";
		}else{
			condition123 += "`id` is null";
		}
		return this;
	}
	public CartInfoCriteria andIdIsNotNull(){
		if(condition123.length()>0){
			condition123 += "and `id` is not null";
		}else{
			condition123 += "`id` is not null";
		}
		return this;
	}
	public CartInfoCriteria orIdIsNotNull(){
		if(condition123.length()>0){
			condition123 += "or `id` is not null";
		}else{
			condition123 += "`id` is not null";
		}
		return this;
	}
	public CartInfoCriteria andIdIn(String value){
		if(value!=null && value.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `id` in("+value+") ";
			}else{
				condition123 += "`id` in("+value+") ";
			}
		}
		return this;
	}
	public CartInfoCriteria orIdIn(String value){
		if(value!=null && value.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `id` in("+value+") ";
			}else{
				condition123 += "`id` in("+value+") ";
			}
		}
		return this;
	}
	public CartInfoCriteria andIdNotIn(String value){
		if(value!=null && value.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `id` not in("+value+") ";
			}else{
				condition123 += "`id` not in("+value+") ";
			}
		}
		return this;
	}
	public CartInfoCriteria orIdNotIn(String value){
		if(value!=null && value.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `id` not in("+value+") ";
			}else{
				condition123 += "`id` not in("+value+") ";
			}
		}
		return this;
	}

	public CartInfoCriteria andUserIdEquals(Integer userId){
		if(userId!=null){
			if(condition123.length()>0){
				condition123 += "and `user_id`="+userId+" ";
			}else{
				condition123 += "`user_id`="+userId+" ";
			}
		}
		return this;
	}
	
	public CartInfoCriteria orUserIdEquals(Integer userId){
		if(userId!=null){
			if(condition123.length()>0){
				condition123 += "or `user_id`="+userId+" ";
			}else{
				condition123 += "`user_id`="+userId+" ";
			}
		}
		return this;
	}
	
	public CartInfoCriteria andUserIdNotEquals(Integer userId){
		if(userId!=null){
			if(condition123.length()>0){
				condition123 += "and `user_id`!="+userId+" ";
			}else{
				condition123 += "`user_id`!="+userId+" ";
			}
		}
		return this;
	}
	public CartInfoCriteria orUserIdNotEquals(Integer userId){
		if(userId!=null){
			if(condition123.length()>0){
				condition123 += "or `user_id`!="+userId+" ";
			}else{
				condition123 += "`user_id`!="+userId+" ";
			}
		}
		return this;
	}
	/**
	 * 大于
	 * @param 
	 * @return
	 */
	public CartInfoCriteria andUserIdGreaterThan(Integer userId){
		if(userId!=null){
			if(condition123.length()>0){
				condition123 += "and `user_id`>"+userId+" ";
			}else{
				condition123 += "`user_id`>"+userId+" ";
			}
		}
		return this;
	}
	public CartInfoCriteria orUserIdGreaterThan(Integer userId){
		if(userId!=null){
			if(condition123.length()>0){
				condition123 += "or `user_id`>"+userId+" ";
			}else{
				condition123 += "`user_id`>"+userId+" ";
			}
		}
		return this;
	}
	
	
	public CartInfoCriteria andUserIdLessThan(Integer userId){
		if(userId!=null){
			if(condition123.length()>0){
				condition123 += "and `user_id`<"+userId+" ";
			}else{
				condition123 += "`user_id`<"+userId+" ";
			}
		}
		return this;
	}
	public CartInfoCriteria orUserIdLessThan(Integer userId){
		if(userId!=null){
			if(condition123.length()>0){
				condition123 += "or `user_id`<"+userId+" ";
			}else{
				condition123 += "`user_id`<"+userId+" ";
			}
		}
		return this;
	}
	
	public CartInfoCriteria andUserIdGreadterThanAndEquals(Integer userId){
		if(userId!=null){
			if(condition123.length()>0){
				condition123 += "and `user_id`>="+userId+" ";
			}else{
				condition123 += "`user_id`>="+userId+" ";
			}
		}
		return this;
	}
	public CartInfoCriteria orUserIdGreadterThanAndEquals(Integer userId){
		if(userId!=null){
			if(condition123.length()>0){
				condition123 += "or `user_id`>="+userId+" ";
			}else{
				condition123 += "`user_id`>="+userId+" ";
			}
		}
		return this;
	}
	
	public CartInfoCriteria andUserIdLessThanAndEquals(Integer userId){
		if(userId!=null){
			if(condition123.length()>0){
				condition123 += "and `user_id`<="+userId+" ";
			}else{
				condition123 += "`user_id`<="+userId+" ";
			}
		}
		return this;
	}
	public CartInfoCriteria orUserIdLessThanAndEquals(Integer userId){
		if(userId!=null){
			if(condition123.length()>0){
				condition123 += "or `user_id`<="+userId+" ";
			}else{
				condition123 += "`user_id`<="+userId+" ";
			}
		}
		return this;
	}
	
	public CartInfoCriteria andUserIdLike(Integer userId){
		if(userId!=null){
			if(condition123.length()>0){
				condition123 += "and `user_id` like "+userId+" ";
			}else{
				condition123 += "`user_id` like "+userId+" ";
			}
		}
		return this;
	}
	public CartInfoCriteria orUserIdLike(Integer userId){
		if(userId!=null){
			if(condition123.length()>0){
				condition123 += "or `user_id` like "+userId+" ";
			}else{
				condition123 += "`user_id` like "+userId+" ";
			}
		}
		return this;
	}
	
	public CartInfoCriteria andUserIdIsNull(){
			if(condition123.length()>0){
				condition123 += "and `user_id` is null";
			}else{
				condition123 += "`user_id` is null";
			}
		return this;
	}
	public CartInfoCriteria orUserIdIsNull(){
		if(condition123.length()>0){
			condition123 += "or `user_id` is null";
		}else{
			condition123 += "`user_id` is null";
		}
		return this;
	}
	public CartInfoCriteria andUserIdIsNotNull(){
		if(condition123.length()>0){
			condition123 += "and `user_id` is not null";
		}else{
			condition123 += "`user_id` is not null";
		}
		return this;
	}
	public CartInfoCriteria orUserIdIsNotNull(){
		if(condition123.length()>0){
			condition123 += "or `user_id` is not null";
		}else{
			condition123 += "`user_id` is not null";
		}
		return this;
	}
	public CartInfoCriteria andUserIdIn(String value){
		if(value!=null && value.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `user_id` in("+value+") ";
			}else{
				condition123 += "`user_id` in("+value+") ";
			}
		}
		return this;
	}
	public CartInfoCriteria orUserIdIn(String value){
		if(value!=null && value.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `user_id` in("+value+") ";
			}else{
				condition123 += "`user_id` in("+value+") ";
			}
		}
		return this;
	}
	public CartInfoCriteria andUserIdNotIn(String value){
		if(value!=null && value.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `user_id` not in("+value+") ";
			}else{
				condition123 += "`user_id` not in("+value+") ";
			}
		}
		return this;
	}
	public CartInfoCriteria orUserIdNotIn(String value){
		if(value!=null && value.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `user_id` not in("+value+") ";
			}else{
				condition123 += "`user_id` not in("+value+") ";
			}
		}
		return this;
	}

	public CartInfoCriteria andGoodsIdEquals(Integer goodsId){
		if(goodsId!=null){
			if(condition123.length()>0){
				condition123 += "and `goods_id`="+goodsId+" ";
			}else{
				condition123 += "`goods_id`="+goodsId+" ";
			}
		}
		return this;
	}
	
	public CartInfoCriteria orGoodsIdEquals(Integer goodsId){
		if(goodsId!=null){
			if(condition123.length()>0){
				condition123 += "or `goods_id`="+goodsId+" ";
			}else{
				condition123 += "`goods_id`="+goodsId+" ";
			}
		}
		return this;
	}
	
	public CartInfoCriteria andGoodsIdNotEquals(Integer goodsId){
		if(goodsId!=null){
			if(condition123.length()>0){
				condition123 += "and `goods_id`!="+goodsId+" ";
			}else{
				condition123 += "`goods_id`!="+goodsId+" ";
			}
		}
		return this;
	}
	public CartInfoCriteria orGoodsIdNotEquals(Integer goodsId){
		if(goodsId!=null){
			if(condition123.length()>0){
				condition123 += "or `goods_id`!="+goodsId+" ";
			}else{
				condition123 += "`goods_id`!="+goodsId+" ";
			}
		}
		return this;
	}
	/**
	 * 大于
	 * @param 
	 * @return
	 */
	public CartInfoCriteria andGoodsIdGreaterThan(Integer goodsId){
		if(goodsId!=null){
			if(condition123.length()>0){
				condition123 += "and `goods_id`>"+goodsId+" ";
			}else{
				condition123 += "`goods_id`>"+goodsId+" ";
			}
		}
		return this;
	}
	public CartInfoCriteria orGoodsIdGreaterThan(Integer goodsId){
		if(goodsId!=null){
			if(condition123.length()>0){
				condition123 += "or `goods_id`>"+goodsId+" ";
			}else{
				condition123 += "`goods_id`>"+goodsId+" ";
			}
		}
		return this;
	}
	
	
	public CartInfoCriteria andGoodsIdLessThan(Integer goodsId){
		if(goodsId!=null){
			if(condition123.length()>0){
				condition123 += "and `goods_id`<"+goodsId+" ";
			}else{
				condition123 += "`goods_id`<"+goodsId+" ";
			}
		}
		return this;
	}
	public CartInfoCriteria orGoodsIdLessThan(Integer goodsId){
		if(goodsId!=null){
			if(condition123.length()>0){
				condition123 += "or `goods_id`<"+goodsId+" ";
			}else{
				condition123 += "`goods_id`<"+goodsId+" ";
			}
		}
		return this;
	}
	
	public CartInfoCriteria andGoodsIdGreadterThanAndEquals(Integer goodsId){
		if(goodsId!=null){
			if(condition123.length()>0){
				condition123 += "and `goods_id`>="+goodsId+" ";
			}else{
				condition123 += "`goods_id`>="+goodsId+" ";
			}
		}
		return this;
	}
	public CartInfoCriteria orGoodsIdGreadterThanAndEquals(Integer goodsId){
		if(goodsId!=null){
			if(condition123.length()>0){
				condition123 += "or `goods_id`>="+goodsId+" ";
			}else{
				condition123 += "`goods_id`>="+goodsId+" ";
			}
		}
		return this;
	}
	
	public CartInfoCriteria andGoodsIdLessThanAndEquals(Integer goodsId){
		if(goodsId!=null){
			if(condition123.length()>0){
				condition123 += "and `goods_id`<="+goodsId+" ";
			}else{
				condition123 += "`goods_id`<="+goodsId+" ";
			}
		}
		return this;
	}
	public CartInfoCriteria orGoodsIdLessThanAndEquals(Integer goodsId){
		if(goodsId!=null){
			if(condition123.length()>0){
				condition123 += "or `goods_id`<="+goodsId+" ";
			}else{
				condition123 += "`goods_id`<="+goodsId+" ";
			}
		}
		return this;
	}
	
	public CartInfoCriteria andGoodsIdLike(Integer goodsId){
		if(goodsId!=null){
			if(condition123.length()>0){
				condition123 += "and `goods_id` like "+goodsId+" ";
			}else{
				condition123 += "`goods_id` like "+goodsId+" ";
			}
		}
		return this;
	}
	public CartInfoCriteria orGoodsIdLike(Integer goodsId){
		if(goodsId!=null){
			if(condition123.length()>0){
				condition123 += "or `goods_id` like "+goodsId+" ";
			}else{
				condition123 += "`goods_id` like "+goodsId+" ";
			}
		}
		return this;
	}
	
	public CartInfoCriteria andGoodsIdIsNull(){
			if(condition123.length()>0){
				condition123 += "and `goods_id` is null";
			}else{
				condition123 += "`goods_id` is null";
			}
		return this;
	}
	public CartInfoCriteria orGoodsIdIsNull(){
		if(condition123.length()>0){
			condition123 += "or `goods_id` is null";
		}else{
			condition123 += "`goods_id` is null";
		}
		return this;
	}
	public CartInfoCriteria andGoodsIdIsNotNull(){
		if(condition123.length()>0){
			condition123 += "and `goods_id` is not null";
		}else{
			condition123 += "`goods_id` is not null";
		}
		return this;
	}
	public CartInfoCriteria orGoodsIdIsNotNull(){
		if(condition123.length()>0){
			condition123 += "or `goods_id` is not null";
		}else{
			condition123 += "`goods_id` is not null";
		}
		return this;
	}
	public CartInfoCriteria andGoodsIdIn(String value){
		if(value!=null && value.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `goods_id` in("+value+") ";
			}else{
				condition123 += "`goods_id` in("+value+") ";
			}
		}
		return this;
	}
	public CartInfoCriteria orGoodsIdIn(String value){
		if(value!=null && value.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `goods_id` in("+value+") ";
			}else{
				condition123 += "`goods_id` in("+value+") ";
			}
		}
		return this;
	}
	public CartInfoCriteria andGoodsIdNotIn(String value){
		if(value!=null && value.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `goods_id` not in("+value+") ";
			}else{
				condition123 += "`goods_id` not in("+value+") ";
			}
		}
		return this;
	}
	public CartInfoCriteria orGoodsIdNotIn(String value){
		if(value!=null && value.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `goods_id` not in("+value+") ";
			}else{
				condition123 += "`goods_id` not in("+value+") ";
			}
		}
		return this;
	}

	public CartInfoCriteria andGoodsPriceEquals(Integer goodsPrice){
		if(goodsPrice!=null){
			if(condition123.length()>0){
				condition123 += "and `goods_price`="+goodsPrice+" ";
			}else{
				condition123 += "`goods_price`="+goodsPrice+" ";
			}
		}
		return this;
	}
	
	public CartInfoCriteria orGoodsPriceEquals(Integer goodsPrice){
		if(goodsPrice!=null){
			if(condition123.length()>0){
				condition123 += "or `goods_price`="+goodsPrice+" ";
			}else{
				condition123 += "`goods_price`="+goodsPrice+" ";
			}
		}
		return this;
	}
	
	public CartInfoCriteria andGoodsPriceNotEquals(Integer goodsPrice){
		if(goodsPrice!=null){
			if(condition123.length()>0){
				condition123 += "and `goods_price`!="+goodsPrice+" ";
			}else{
				condition123 += "`goods_price`!="+goodsPrice+" ";
			}
		}
		return this;
	}
	public CartInfoCriteria orGoodsPriceNotEquals(Integer goodsPrice){
		if(goodsPrice!=null){
			if(condition123.length()>0){
				condition123 += "or `goods_price`!="+goodsPrice+" ";
			}else{
				condition123 += "`goods_price`!="+goodsPrice+" ";
			}
		}
		return this;
	}
	/**
	 * 大于
	 * @param 
	 * @return
	 */
	public CartInfoCriteria andGoodsPriceGreaterThan(Integer goodsPrice){
		if(goodsPrice!=null){
			if(condition123.length()>0){
				condition123 += "and `goods_price`>"+goodsPrice+" ";
			}else{
				condition123 += "`goods_price`>"+goodsPrice+" ";
			}
		}
		return this;
	}
	public CartInfoCriteria orGoodsPriceGreaterThan(Integer goodsPrice){
		if(goodsPrice!=null){
			if(condition123.length()>0){
				condition123 += "or `goods_price`>"+goodsPrice+" ";
			}else{
				condition123 += "`goods_price`>"+goodsPrice+" ";
			}
		}
		return this;
	}
	
	
	public CartInfoCriteria andGoodsPriceLessThan(Integer goodsPrice){
		if(goodsPrice!=null){
			if(condition123.length()>0){
				condition123 += "and `goods_price`<"+goodsPrice+" ";
			}else{
				condition123 += "`goods_price`<"+goodsPrice+" ";
			}
		}
		return this;
	}
	public CartInfoCriteria orGoodsPriceLessThan(Integer goodsPrice){
		if(goodsPrice!=null){
			if(condition123.length()>0){
				condition123 += "or `goods_price`<"+goodsPrice+" ";
			}else{
				condition123 += "`goods_price`<"+goodsPrice+" ";
			}
		}
		return this;
	}
	
	public CartInfoCriteria andGoodsPriceGreadterThanAndEquals(Integer goodsPrice){
		if(goodsPrice!=null){
			if(condition123.length()>0){
				condition123 += "and `goods_price`>="+goodsPrice+" ";
			}else{
				condition123 += "`goods_price`>="+goodsPrice+" ";
			}
		}
		return this;
	}
	public CartInfoCriteria orGoodsPriceGreadterThanAndEquals(Integer goodsPrice){
		if(goodsPrice!=null){
			if(condition123.length()>0){
				condition123 += "or `goods_price`>="+goodsPrice+" ";
			}else{
				condition123 += "`goods_price`>="+goodsPrice+" ";
			}
		}
		return this;
	}
	
	public CartInfoCriteria andGoodsPriceLessThanAndEquals(Integer goodsPrice){
		if(goodsPrice!=null){
			if(condition123.length()>0){
				condition123 += "and `goods_price`<="+goodsPrice+" ";
			}else{
				condition123 += "`goods_price`<="+goodsPrice+" ";
			}
		}
		return this;
	}
	public CartInfoCriteria orGoodsPriceLessThanAndEquals(Integer goodsPrice){
		if(goodsPrice!=null){
			if(condition123.length()>0){
				condition123 += "or `goods_price`<="+goodsPrice+" ";
			}else{
				condition123 += "`goods_price`<="+goodsPrice+" ";
			}
		}
		return this;
	}
	
	public CartInfoCriteria andGoodsPriceLike(Integer goodsPrice){
		if(goodsPrice!=null){
			if(condition123.length()>0){
				condition123 += "and `goods_price` like "+goodsPrice+" ";
			}else{
				condition123 += "`goods_price` like "+goodsPrice+" ";
			}
		}
		return this;
	}
	public CartInfoCriteria orGoodsPriceLike(Integer goodsPrice){
		if(goodsPrice!=null){
			if(condition123.length()>0){
				condition123 += "or `goods_price` like "+goodsPrice+" ";
			}else{
				condition123 += "`goods_price` like "+goodsPrice+" ";
			}
		}
		return this;
	}
	
	public CartInfoCriteria andGoodsPriceIsNull(){
			if(condition123.length()>0){
				condition123 += "and `goods_price` is null";
			}else{
				condition123 += "`goods_price` is null";
			}
		return this;
	}
	public CartInfoCriteria orGoodsPriceIsNull(){
		if(condition123.length()>0){
			condition123 += "or `goods_price` is null";
		}else{
			condition123 += "`goods_price` is null";
		}
		return this;
	}
	public CartInfoCriteria andGoodsPriceIsNotNull(){
		if(condition123.length()>0){
			condition123 += "and `goods_price` is not null";
		}else{
			condition123 += "`goods_price` is not null";
		}
		return this;
	}
	public CartInfoCriteria orGoodsPriceIsNotNull(){
		if(condition123.length()>0){
			condition123 += "or `goods_price` is not null";
		}else{
			condition123 += "`goods_price` is not null";
		}
		return this;
	}
	public CartInfoCriteria andGoodsPriceIn(String value){
		if(value!=null && value.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `goods_price` in("+value+") ";
			}else{
				condition123 += "`goods_price` in("+value+") ";
			}
		}
		return this;
	}
	public CartInfoCriteria orGoodsPriceIn(String value){
		if(value!=null && value.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `goods_price` in("+value+") ";
			}else{
				condition123 += "`goods_price` in("+value+") ";
			}
		}
		return this;
	}
	public CartInfoCriteria andGoodsPriceNotIn(String value){
		if(value!=null && value.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `goods_price` not in("+value+") ";
			}else{
				condition123 += "`goods_price` not in("+value+") ";
			}
		}
		return this;
	}
	public CartInfoCriteria orGoodsPriceNotIn(String value){
		if(value!=null && value.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `goods_price` not in("+value+") ";
			}else{
				condition123 += "`goods_price` not in("+value+") ";
			}
		}
		return this;
	}

	public CartInfoCriteria andGoodsNumberEquals(Integer goodsNumber){
		if(goodsNumber!=null){
			if(condition123.length()>0){
				condition123 += "and `goods_number`="+goodsNumber+" ";
			}else{
				condition123 += "`goods_number`="+goodsNumber+" ";
			}
		}
		return this;
	}
	
	public CartInfoCriteria orGoodsNumberEquals(Integer goodsNumber){
		if(goodsNumber!=null){
			if(condition123.length()>0){
				condition123 += "or `goods_number`="+goodsNumber+" ";
			}else{
				condition123 += "`goods_number`="+goodsNumber+" ";
			}
		}
		return this;
	}
	
	public CartInfoCriteria andGoodsNumberNotEquals(Integer goodsNumber){
		if(goodsNumber!=null){
			if(condition123.length()>0){
				condition123 += "and `goods_number`!="+goodsNumber+" ";
			}else{
				condition123 += "`goods_number`!="+goodsNumber+" ";
			}
		}
		return this;
	}
	public CartInfoCriteria orGoodsNumberNotEquals(Integer goodsNumber){
		if(goodsNumber!=null){
			if(condition123.length()>0){
				condition123 += "or `goods_number`!="+goodsNumber+" ";
			}else{
				condition123 += "`goods_number`!="+goodsNumber+" ";
			}
		}
		return this;
	}
	/**
	 * 大于
	 * @param 
	 * @return
	 */
	public CartInfoCriteria andGoodsNumberGreaterThan(Integer goodsNumber){
		if(goodsNumber!=null){
			if(condition123.length()>0){
				condition123 += "and `goods_number`>"+goodsNumber+" ";
			}else{
				condition123 += "`goods_number`>"+goodsNumber+" ";
			}
		}
		return this;
	}
	public CartInfoCriteria orGoodsNumberGreaterThan(Integer goodsNumber){
		if(goodsNumber!=null){
			if(condition123.length()>0){
				condition123 += "or `goods_number`>"+goodsNumber+" ";
			}else{
				condition123 += "`goods_number`>"+goodsNumber+" ";
			}
		}
		return this;
	}
	
	
	public CartInfoCriteria andGoodsNumberLessThan(Integer goodsNumber){
		if(goodsNumber!=null){
			if(condition123.length()>0){
				condition123 += "and `goods_number`<"+goodsNumber+" ";
			}else{
				condition123 += "`goods_number`<"+goodsNumber+" ";
			}
		}
		return this;
	}
	public CartInfoCriteria orGoodsNumberLessThan(Integer goodsNumber){
		if(goodsNumber!=null){
			if(condition123.length()>0){
				condition123 += "or `goods_number`<"+goodsNumber+" ";
			}else{
				condition123 += "`goods_number`<"+goodsNumber+" ";
			}
		}
		return this;
	}
	
	public CartInfoCriteria andGoodsNumberGreadterThanAndEquals(Integer goodsNumber){
		if(goodsNumber!=null){
			if(condition123.length()>0){
				condition123 += "and `goods_number`>="+goodsNumber+" ";
			}else{
				condition123 += "`goods_number`>="+goodsNumber+" ";
			}
		}
		return this;
	}
	public CartInfoCriteria orGoodsNumberGreadterThanAndEquals(Integer goodsNumber){
		if(goodsNumber!=null){
			if(condition123.length()>0){
				condition123 += "or `goods_number`>="+goodsNumber+" ";
			}else{
				condition123 += "`goods_number`>="+goodsNumber+" ";
			}
		}
		return this;
	}
	
	public CartInfoCriteria andGoodsNumberLessThanAndEquals(Integer goodsNumber){
		if(goodsNumber!=null){
			if(condition123.length()>0){
				condition123 += "and `goods_number`<="+goodsNumber+" ";
			}else{
				condition123 += "`goods_number`<="+goodsNumber+" ";
			}
		}
		return this;
	}
	public CartInfoCriteria orGoodsNumberLessThanAndEquals(Integer goodsNumber){
		if(goodsNumber!=null){
			if(condition123.length()>0){
				condition123 += "or `goods_number`<="+goodsNumber+" ";
			}else{
				condition123 += "`goods_number`<="+goodsNumber+" ";
			}
		}
		return this;
	}
	
	public CartInfoCriteria andGoodsNumberLike(Integer goodsNumber){
		if(goodsNumber!=null){
			if(condition123.length()>0){
				condition123 += "and `goods_number` like "+goodsNumber+" ";
			}else{
				condition123 += "`goods_number` like "+goodsNumber+" ";
			}
		}
		return this;
	}
	public CartInfoCriteria orGoodsNumberLike(Integer goodsNumber){
		if(goodsNumber!=null){
			if(condition123.length()>0){
				condition123 += "or `goods_number` like "+goodsNumber+" ";
			}else{
				condition123 += "`goods_number` like "+goodsNumber+" ";
			}
		}
		return this;
	}
	
	public CartInfoCriteria andGoodsNumberIsNull(){
			if(condition123.length()>0){
				condition123 += "and `goods_number` is null";
			}else{
				condition123 += "`goods_number` is null";
			}
		return this;
	}
	public CartInfoCriteria orGoodsNumberIsNull(){
		if(condition123.length()>0){
			condition123 += "or `goods_number` is null";
		}else{
			condition123 += "`goods_number` is null";
		}
		return this;
	}
	public CartInfoCriteria andGoodsNumberIsNotNull(){
		if(condition123.length()>0){
			condition123 += "and `goods_number` is not null";
		}else{
			condition123 += "`goods_number` is not null";
		}
		return this;
	}
	public CartInfoCriteria orGoodsNumberIsNotNull(){
		if(condition123.length()>0){
			condition123 += "or `goods_number` is not null";
		}else{
			condition123 += "`goods_number` is not null";
		}
		return this;
	}
	public CartInfoCriteria andGoodsNumberIn(String value){
		if(value!=null && value.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `goods_number` in("+value+") ";
			}else{
				condition123 += "`goods_number` in("+value+") ";
			}
		}
		return this;
	}
	public CartInfoCriteria orGoodsNumberIn(String value){
		if(value!=null && value.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `goods_number` in("+value+") ";
			}else{
				condition123 += "`goods_number` in("+value+") ";
			}
		}
		return this;
	}
	public CartInfoCriteria andGoodsNumberNotIn(String value){
		if(value!=null && value.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `goods_number` not in("+value+") ";
			}else{
				condition123 += "`goods_number` not in("+value+") ";
			}
		}
		return this;
	}
	public CartInfoCriteria orGoodsNumberNotIn(String value){
		if(value!=null && value.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `goods_number` not in("+value+") ";
			}else{
				condition123 += "`goods_number` not in("+value+") ";
			}
		}
		return this;
	}

	public CartInfoCriteria andCreateDateEquals(String createDate){
		if(createDate!=null&&createDate.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `create_date`='"+createDate+"' ";
			}else{
				condition123 += "`create_date`='"+createDate+"' ";
			}
		}
		return this;
	}
	
	public CartInfoCriteria orCreateDateEquals(String createDate){
		if(createDate!=null&&createDate.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `create_date`='"+createDate+"' ";
			}else{
				condition123 += "`create_date`='"+createDate+"' ";
			}
		}
		return this;
	}
	
	public CartInfoCriteria andCreateDateNotEquals(String createDate){
		if(createDate!=null&&createDate.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `create_date`!='"+createDate+"' ";
			}else{
				condition123 += "`create_date`!='"+createDate+"' ";
			}
		}
		return this;
	}
	public CartInfoCriteria orCreateDateNotEquals(String createDate){
		if(createDate!=null&&createDate.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `create_date`!='"+createDate+"' ";
			}else{
				condition123 += "`create_date`!='"+createDate+"' ";
			}
		}
		return this;
	}
	/**
	 * 大于
	 * @param 
	 * @return
	 */
	public CartInfoCriteria andCreateDateGreaterThan(String createDate){
		if(createDate!=null&&createDate.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `create_date`>'"+createDate+"' ";
			}else{
				condition123 += "`create_date`>'"+createDate+"' ";
			}
		}
		return this;
	}
	public CartInfoCriteria orCreateDateGreaterThan(String createDate){
		if(createDate!=null&&createDate.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `create_date`>'"+createDate+"' ";
			}else{
				condition123 += "`create_date`>'"+createDate+"' ";
			}
		}
		return this;
	}
	
	
	public CartInfoCriteria andCreateDateLessThan(String createDate){
		if(createDate!=null&&createDate.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `create_date`<'"+createDate+"' ";
			}else{
				condition123 += "`create_date`<'"+createDate+"' ";
			}
		}
		return this;
	}
	public CartInfoCriteria orCreateDateLessThan(String createDate){
		if(createDate!=null&&createDate.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `create_date`<'"+createDate+"' ";
			}else{
				condition123 += "`create_date`<'"+createDate+"' ";
			}
		}
		return this;
	}
	
	public CartInfoCriteria andCreateDateGreadterThanAndEquals(String createDate){
		if(createDate!=null&&createDate.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `create_date`>='"+createDate+"' ";
			}else{
				condition123 += "`create_date`>='"+createDate+"' ";
			}
		}
		return this;
	}
	public CartInfoCriteria orCreateDateGreadterThanAndEquals(String createDate){
		if(createDate!=null&&createDate.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `create_date`>='"+createDate+"' ";
			}else{
				condition123 += "`create_date`>='"+createDate+"' ";
			}
		}
		return this;
	}
	
	public CartInfoCriteria andCreateDateLessThanAndEquals(String createDate){
		if(createDate!=null&&createDate.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `create_date`<='"+createDate+"' ";
			}else{
				condition123 += "`create_date`<='"+createDate+"' ";
			}
		}
		return this;
	}
	public CartInfoCriteria orCreateDateLessThanAndEquals(String createDate){
		if(createDate!=null&&createDate.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `create_date`<='"+createDate+"' ";
			}else{
				condition123 += "`create_date`<='"+createDate+"' ";
			}
		}
		return this;
	}
	
	public CartInfoCriteria andCreateDateLike(String createDate){
		if(createDate!=null&&createDate.trim().length()>0&&!("%".equals(createDate.trim()))&&!("%%".equals(createDate.trim()))){
			if(condition123.length()>0){
				condition123 += "and `create_date` like '"+createDate+"' ";
			}else{
				condition123 += "`create_date` like '"+createDate+"' ";
			}
		}
		return this;
	}
	public CartInfoCriteria orCreateDateLike(String createDate){
		if(createDate!=null&&createDate.trim().length()>0&&!("%".equals(createDate.trim()))&&!("%%".equals(createDate.trim()))){
			if(condition123.length()>0){
				condition123 += "or `create_date` like '"+createDate+"' ";
			}else{
				condition123 += "`create_date` like '"+createDate+"' ";
			}
		}
		return this;
	}
	
	public CartInfoCriteria andCreateDateIsNull(){
			if(condition123.length()>0){
				condition123 += "and `create_date` is null";
			}else{
				condition123 += "`create_date` is null";
			}
		return this;
	}
	public CartInfoCriteria orCreateDateIsNull(){
		if(condition123.length()>0){
			condition123 += "or `create_date` is null";
		}else{
			condition123 += "`create_date` is null";
		}
		return this;
	}
	public CartInfoCriteria andCreateDateIsNotNull(){
		if(condition123.length()>0){
			condition123 += "and `create_date` is not null";
		}else{
			condition123 += "`create_date` is not null";
		}
		return this;
	}
	public CartInfoCriteria orCreateDateIsNotNull(){
		if(condition123.length()>0){
			condition123 += "or `create_date` is not null";
		}else{
			condition123 += "`create_date` is not null";
		}
		return this;
	}
	
	public CartInfoCriteria andCreateDateIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "and `create_date` in("+value+") ";
			}else{
				condition123 += "`create_date` in("+value+") ";
			}
		}
		return this;
	}
	
	public CartInfoCriteria orCreateDateIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "or `create_date` in("+value+") ";
			}else{
				condition123 += "`create_date` in("+value+") ";
			}
		}
		return this;
	}
	
	public CartInfoCriteria andCreateDateNotIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "and `create_date` not in("+value+") ";
			}else{
				condition123 += "`create_date` not in("+value+") ";
			}
		}
		return this;
	}
	
	public CartInfoCriteria orCreateDateNotIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "or `create_date` not in("+value+") ";
			}else{
				condition123 += "`create_date` not in("+value+") ";
			}
		}
		return this;
	}

	public CartInfoCriteria andStateEquals(String state){
		if(state!=null&&state.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `state`='"+state+"' ";
			}else{
				condition123 += "`state`='"+state+"' ";
			}
		}
		return this;
	}
	
	public CartInfoCriteria orStateEquals(String state){
		if(state!=null&&state.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `state`='"+state+"' ";
			}else{
				condition123 += "`state`='"+state+"' ";
			}
		}
		return this;
	}
	
	public CartInfoCriteria andStateNotEquals(String state){
		if(state!=null&&state.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `state`!='"+state+"' ";
			}else{
				condition123 += "`state`!='"+state+"' ";
			}
		}
		return this;
	}
	public CartInfoCriteria orStateNotEquals(String state){
		if(state!=null&&state.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `state`!='"+state+"' ";
			}else{
				condition123 += "`state`!='"+state+"' ";
			}
		}
		return this;
	}
	/**
	 * 大于
	 * @param 
	 * @return
	 */
	public CartInfoCriteria andStateGreaterThan(String state){
		if(state!=null&&state.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `state`>'"+state+"' ";
			}else{
				condition123 += "`state`>'"+state+"' ";
			}
		}
		return this;
	}
	public CartInfoCriteria orStateGreaterThan(String state){
		if(state!=null&&state.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `state`>'"+state+"' ";
			}else{
				condition123 += "`state`>'"+state+"' ";
			}
		}
		return this;
	}
	
	
	public CartInfoCriteria andStateLessThan(String state){
		if(state!=null&&state.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `state`<'"+state+"' ";
			}else{
				condition123 += "`state`<'"+state+"' ";
			}
		}
		return this;
	}
	public CartInfoCriteria orStateLessThan(String state){
		if(state!=null&&state.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `state`<'"+state+"' ";
			}else{
				condition123 += "`state`<'"+state+"' ";
			}
		}
		return this;
	}
	
	public CartInfoCriteria andStateGreadterThanAndEquals(String state){
		if(state!=null&&state.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `state`>='"+state+"' ";
			}else{
				condition123 += "`state`>='"+state+"' ";
			}
		}
		return this;
	}
	public CartInfoCriteria orStateGreadterThanAndEquals(String state){
		if(state!=null&&state.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `state`>='"+state+"' ";
			}else{
				condition123 += "`state`>='"+state+"' ";
			}
		}
		return this;
	}
	
	public CartInfoCriteria andStateLessThanAndEquals(String state){
		if(state!=null&&state.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "and `state`<='"+state+"' ";
			}else{
				condition123 += "`state`<='"+state+"' ";
			}
		}
		return this;
	}
	public CartInfoCriteria orStateLessThanAndEquals(String state){
		if(state!=null&&state.trim().length()>0){
			if(condition123.length()>0){
				condition123 += "or `state`<='"+state+"' ";
			}else{
				condition123 += "`state`<='"+state+"' ";
			}
		}
		return this;
	}
	
	public CartInfoCriteria andStateLike(String state){
		if(state!=null&&state.trim().length()>0&&!("%".equals(state.trim()))&&!("%%".equals(state.trim()))){
			if(condition123.length()>0){
				condition123 += "and `state` like '"+state+"' ";
			}else{
				condition123 += "`state` like '"+state+"' ";
			}
		}
		return this;
	}
	public CartInfoCriteria orStateLike(String state){
		if(state!=null&&state.trim().length()>0&&!("%".equals(state.trim()))&&!("%%".equals(state.trim()))){
			if(condition123.length()>0){
				condition123 += "or `state` like '"+state+"' ";
			}else{
				condition123 += "`state` like '"+state+"' ";
			}
		}
		return this;
	}
	
	public CartInfoCriteria andStateIsNull(){
			if(condition123.length()>0){
				condition123 += "and `state` is null";
			}else{
				condition123 += "`state` is null";
			}
		return this;
	}
	public CartInfoCriteria orStateIsNull(){
		if(condition123.length()>0){
			condition123 += "or `state` is null";
		}else{
			condition123 += "`state` is null";
		}
		return this;
	}
	public CartInfoCriteria andStateIsNotNull(){
		if(condition123.length()>0){
			condition123 += "and `state` is not null";
		}else{
			condition123 += "`state` is not null";
		}
		return this;
	}
	public CartInfoCriteria orStateIsNotNull(){
		if(condition123.length()>0){
			condition123 += "or `state` is not null";
		}else{
			condition123 += "`state` is not null";
		}
		return this;
	}
	
	public CartInfoCriteria andStateIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "and `state` in("+value+") ";
			}else{
				condition123 += "`state` in("+value+") ";
			}
		}
		return this;
	}
	
	public CartInfoCriteria orStateIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "or `state` in("+value+") ";
			}else{
				condition123 += "`state` in("+value+") ";
			}
		}
		return this;
	}
	
	public CartInfoCriteria andStateNotIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "and `state` not in("+value+") ";
			}else{
				condition123 += "`state` not in("+value+") ";
			}
		}
		return this;
	}
	
	public CartInfoCriteria orStateNotIn(String value){
		if(value!=null&&value.trim().length()>0){
			if(value.contains(",")){
				String []values = value.split(",");
				String newValue = "";
				for(String s:values){
					newValue += "'"+s+"',";
				}
				newValue = newValue.substring(0, newValue.length()-1);
				value = newValue;
			}else{
				value = "'"+value+"'";
			}
			if(condition123.length()>0){
				condition123 += "or `state` not in("+value+") ";
			}else{
				condition123 += "`state` not in("+value+") ";
			}
		}
		return this;
	}

	private void initCartInfo(CartInfo cartInfo) {
		super.setId(cartInfo.getId());
		super.setUserId(cartInfo.getUserId());
		super.setGoodsId(cartInfo.getGoodsId());
		super.setGoodsPrice(cartInfo.getGoodsPrice());
		super.setGoodsNumber(cartInfo.getGoodsNumber());
		super.setCreateDate(cartInfo.getCreateDate());
		super.setState(cartInfo.getState());

	}

}